<?php
    
    include_once '../../controlador/php/conexion/Conexion.php';
    $con = new Conexion();
    
    $areas = "SELECT OID,HSUCODIGO,HSUNOMBRE FROM ".$con->getReal()."..HPNSUBGRU WHERE OID NOT IN (16,17,18,20,23) ORDER BY HSUNOMBRE ASC";
    $res = $con->query($areas);
    
    while ($res2 = mssql_fetch_array($res)){
        
        $lista[] = $res2;
        
    }
    
    print_r(json_encode($lista));
    
    
    $con->cerrarConexion();
    
?>
